package com.whr.dao;

import com.whr.bean.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ProblemMapper {
    int deleteByPrimaryKey(Integer pid);

    int insert(Problem record);

    Problem selectByPrimaryKey(Integer pid);

    List<Problem> selectAll();

    int updateByPrimaryKey(Problem record);

    void addAppend(@Param("pid")Integer pid, @Param("text")String text);

    List<Append> appendByPid(Integer pid);

    void delProb(Integer[] checks);

    void urgProb(Integer[] checks);

    void fineProb(Integer[] checks);

    List<Problem> selectAllOrder();

    void endProb(Integer[] checks);

    void addReply(@Param("pid")Integer pid, @Param("text")String text);

    List<Reply> replyByPid(Integer pid);

    void addRaty(@Param("pid")Integer pid, @Param("raty")Double raty);

    Double ratyByPid(Integer pid);

    void updateRole(@Param("role")String role, @Param("pid")Integer pid);

    List<Problem> findOver();

    void upOver(@Param("pid")Integer pid, @Param("pover")String pover);

    void pass(Integer[] checks);

    void unpass(Integer[] checks);

    List<Problem> findRep();

    void addReplyState(Integer pid);

    List<Problem> searchRep(Report report);

    List<ChartValue> chartValue();

    void updateProbRol(@Param("oname")String oname,@Param("rname")String rname);

    List<String> findProb7();

    List<String> findFine7();

    List<String> findReply5();

    Integer getYreplay();

    Integer getZreplay();

    Integer findIng();

    Integer findRepc();

    Integer findEnd();

    Integer findOverc();

    List<Problem> selectExcel();

    List<Problem> findZN(String role);

    List<Problem> findYX(String flag);

    List<Problem> findAllZN(String flag);

    List<Problem> findAllYX(String flag);
}